package cn.hr.dao.mapper;

import org.apache.ibatis.annotations.Param;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

/**
 * Created by MO on 2019/1/14.
 */
public interface DataAnalysisMapper {
    /**
     * 根据查询条件查询职员明细
     *
     * @param map
     * @return
     */
    List<Map> findArchivesByCondition(Map map) throws SQLException;

    /**
     * 查询职员数据综合报表
     *
     * @return
     * @throws SQLException
     */
    List<Map> findConsolidatedStaffDataReport() throws SQLException;

    /**
     * 按年份查看职员数据综合报表
     *
     * @param year
     * @return
     * @throws SQLException
     */
    List<Map> findConsolidatedStaffDataReportO(@Param("year") String year) throws SQLException;
}
